USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Employee_UpdateAdvance]    Script Date: 02/10/2012 11:22:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Hainh	
-- Create date: 23/12/2011

-- ========================================
CREATE PROCEDURE [dbo].[Employee_UpdateAdvance]
	-- Add the parameters for the stored procedure here
    @AdvanceID	    BIGINT,
	@EmployeeID		BIGINT,
	@TotalAdvance	BIGINT,
	@Reason		    NVARCHAR(MAX),
	@Note		    NVARCHAR(MAX),
	@DateAdvance	DATETIME

	
AS
BEGIN
	UPDATE Advance
	SET    
		   TotalAdvance= @TotalAdvance,
		   Reason = @Reason	 ,
		   Note = @Note,
	       DateAdvance = @DateAdvance
	Where  AdvanceID = @AdvanceID      
	
END

GO

